home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload Trio 2 / Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO / dir26 / epi601_3.zip / FILES11.EXE / TABLE1.RPT < prev    next >
Text File  |  1994-08-22  |  12KB  |  261 lines
  1. #USESSUM COUNT TIME1 TIME2 COUNTY
  2. *------------------------------------------------------------------------------
  3. * Master report for updating Table1 data by Health region, County, and 
  4. * Disease. It displays information about last week, last 4 weeks and past 
  5. * 52 weeks in the file.
  6. *
  7. * Cutoff for highlighting are as follows: 
  8. *   Cases for current week > Cases for past 3 weeks (> 1/2 total 4 weeks)
  9. *   Cases for past 4 weeks > 2 * average same period 4 years back
  10. *   This can be changed in the formulas...
  11. *
  12. * CALLED BY:   TABLE1.RPT
  13. *
  14. * USES     :   Needs to be compiled (as part of TABLE1.PGM)
  15. *
  16. * Denis Coulombier, last update 05/09/94
  17. *------------------------------------------------------------------------------
  18. .TOPIC INDEX=5000
  19. * First topic for hypertext files should start with anyname, but a =5000
  20.          ~Weekly Report of Notifiable Disease, MMWRWK Nº @CURWEEK, 19@CURYEAR ~
  21.              ~State of Michigan, by Health Region and Counties~
  22.                         Report generated on @SYSTEMDATE
  23.  
  24.          Choose an option for looking at data:
  25.  
  26.         « Notifications for the State     |STATE»
  27.         « Notifications by Health Regions |REGION»
  28.         « Notifications by County         |COUNTY» 
  29.         « Notifications by disease        |DISEASE»
  30.  
  31. This report shows the number of notifications of communicable diseases
  32. received at the Michigan State Health Department, up to week @CURWEEK of
  33. @CURYEAR. It includes counts for the week ^CURWEEK, for the past four weeks, 
  34. and the past 52 weeks. Historical comparisons are made with similar periods
  35. over the past @YEARBACK years.
  36.  
  37. Criteria for ~highlighting~ a county or a disease:
  38.  
  39.        ■ More cases in the current week than in the past 3 weeks
  40. or     ■ Twice as many cases in the past 4 weeks than the average over the 
  41.          past @YEARBACK years.
  42.  
  43. Select «highlighted words|INDEX» to see the corresponding data tables.
  44. You can print data by using <F5>, or copy it to the clipboard using the 
  45. EDIT menu.
  46.  
  47.       ******* WARNING: the data presented here is not real data! *******
  48. .TOPIC COUNTY
  49.  « Index »« State »« Region »« Disease »« Criteria for highlighting |CRITERIA»
  50.  
  51.                  ~Communicable Disease Notification by County~
  52.  
  53.      Select a highlighted county name:
  54.  
  55. #FOREACH COUNTY
  56.     «^COUNTY »\
  57. #IF 2*[1,,^COUNTY] > [,1,^COUNTY] AND [1,,^COUNTY] > 3
  58. ~Cases for week @CURWEEK > past 3 weeks!~
  59. * 3 weeks since Current week is included in the past 4!
  60. #ELSE
  61. #IF [,1,^COUNTY] > {[,2,^COUNTY]/2}:3.1 AND [,1,^COUNTY] > 5
  62. ~Cases for current 4 weeks > 2*average, same 4 weeks~
  63. #ELSE
  64.  
  65. #ENDIF
  66. #ENDFOR
  67. #USESSUM COUNT REGION
  68.  
  69. .TOPIC REGION
  70.  « Index »« County »« State »« Disease »« Criteria for highlighting |CRITERIA»
  71.  
  72.             ~Communicable Disease Notification by Health Regions~
  73.  
  74.      Select a highlighted health region name:
  75.  
  76. #FOREACH REGION
  77.          « Health Region ^REGION |_^REGION »
  78. #ENDFOR
  79.  
  80. #USESSUM COUNT TIME1 TIME2 REGION COUNTY
  81. #FOREACH REGION
  82. .TOPIC _^REGION
  83.  « Region »« County »« State »« Disease »« Criteria for highlighting |CRITERIA»
  84.  
  85.             ~Communicable Disease Notification for Health Region ^REGION ~
  86.  
  87.      Select a highlighted option:
  88.  
  89.      « Notifications for Health Region: ^REGION |^REGION »
  90.  
  91. #FOREACH COUNTY
  92. #IF [,,^REGION,^COUNTY] <> 0
  93.    « ^COUNTY »\
  94. #IF 2*[1,,^REGION,^COUNTY] > [,1,^REGION,^COUNTY] AND [1,,^REGION,^COUNTY] > 3
  95. ~Cases for week @CURWEEK > past 3 weeks!~
  96. * 3 weeks since Current week is included in the past 4!
  97. #ELSE
  98. #IF [,1,^REGION,^COUNTY] > {[,2,^REGION,^COUNTY]/2}:3.1 AND [,1,^REGION,^COUNTY] > 5
  99. ~Cases for current 4 weeks > 2*average, same 4 weeks~
  100. #ELSE
  101. #IF [,,^REGION,^COUNTY] <> 0
  102.  
  103. #ENDIF
  104. #ENDIF
  105. #ENDIF
  106. #ENDIF
  107. #ENDFOR
  108. #ENDFOR
  109.  
  110. #USESSUM COUNT DISEASE TIME1 TIME2 TIME3
  111.  
  112. .TOPIC STATE /NOWRAP
  113.  « Index »« Region »« County »« Disease »« Criteria for highlighting |CRITERIA»
  114.  
  115.                    Table 1. Reported Cases of Selected Notifiable Diseases
  116.                            ~All Counties~ 
  117.                             Week No ~@CURWEEK of 19@CURYEAR ~
  118.  
  119. ┌────────────────────╥─────────╥────────────────────╥─────────────────────┐
  120. │                    ║ MMWR Wk ║ Past 4 week period ║ Past 52 week period │
  121. │ Disease            ║  Nº @CURWEEK  ║  19@CURYEAR    average   ║  19@CURYEAR     average   │
  122. │                    ║   19@CURYEAR  ║   No. │last @YEARBACK years║   No.  │last @YEARBACK years│
  123. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  124. │ Total              ║ [,1]:7 ║[,,1]:6 │  {[,,2]/4}:7.1   ║[,,,1]:7 │  {[,,,2]/4}:7.1   │
  125. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  126. #FOREACH DISEASE
  127. #IF 2*[^DISEASE,1] > [^DISEASE,,1] AND [^DISEASE,1] > 3
  128. │«^DISEASE:20»║ ~[^DISEASE,1]:7~ ║ ~[^DISEASE,,1]:5~ │  {[^DISEASE,,2]/4}:7.1   ║ [^Disease,,,1]:6 │  {[^DISEASE,,,2]/4}:7.1   │
  129. #ELSE
  130. #IF [,^DISEASE,,1] > {[,^DISEASE,,2]/2}:4.1 AND [,^DISEASE,,1] > 5
  131. │«^DISEASE:20»║ [^DISEASE,1]:7 ║ ~[^DISEASE,,1]:5~ │  ~{[^DISEASE,,2]/4}:7.1~   ║ [^Disease,,,1]:6 │  {[^DISEASE,,,2]/4}:7.1   │
  132. #ELSE
  133. │«^DISEASE:20»║ [^DISEASE,1]:7 ║ [^DISEASE,,1]:5 │  {[^DISEASE,,2]/4}:7.1   ║ [^Disease,,,1]:6 │  {[^DISEASE,,,2]/4}:7.1   │
  134. #ENDIF
  135. #ENDIF
  136. #ENDFOR
  137. └────────────────────╨─────────╨───────┴────────────╨────────┴────────────┘
  138.  
  139. #USESSUM COUNT REGION DISEASE TIME1 TIME2 TIME3
  140. #FOREACH REGION
  141. .TOPIC ^REGION /NOWRAP
  142.  « Region |_^REGION »« State »« County »« Disease »« Criteria for highlighting |CRITERIA»
  143.  
  144.                    Table 1. Reported Cases of Selected Notifiable Diseases
  145.                             Region ~^REGION ~ 
  146.                             Week No ~@CURWEEK of 19@CURYEAR ~
  147.  
  148. ┌────────────────────╥─────────╥────────────────────╥─────────────────────┐
  149. │                    ║ MMWR Wk ║ Past 4 week period ║ Past 52 week period │
  150. │ Disease            ║  Nº @CURWEEK  ║  19@CURYEAR    average   ║  19@CURYEAR     average   │
  151. │                    ║   19@CURYEAR  ║   No. │last @YEARBACK years║   No.  │last @YEARBACK years│
  152. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  153. │ Total              ║ [^REGION,,1]:7 ║[^REGION,,,1]:6 │  {[^REGION,,,2]/4}:7.1   ║[^REGION,,,,1]:7 │  {[^REGION,,,,2]/4}:7.1   │
  154. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  155. #FOREACH DISEASE
  156. #IF 2*[^REGION,^DISEASE,1] > [^REGION,^DISEASE,,1] AND [^REGION,^DISEASE,1] > 3
  157. │«^DISEASE:20»║ ~[^REGION,^DISEASE,1]:7~ ║ ~[^REGION,^DISEASE,,1]:5~ │  {[^REGION,^DISEASE,,2]/4}:7.1   ║ [^REGION,^Disease,,,1]:6 │  {[^REGION,^DISEASE,,,2]/4}:7.1   │ 
  158. #ELSE
  159. #IF [^REGION,^DISEASE,,1] > {[^REGION,^DISEASE,,2]/2}:4.1 AND [^REGION,^DISEASE,,1] > 5
  160. │«^DISEASE:20»║ [^REGION,^DISEASE,1]:7 ║ ~[^REGION,^DISEASE,,1]:5~ │  ~{[^REGION,^DISEASE,,2]/4}:7.1~   ║ [^REGION,^Disease,,,1]:6 │  {[^REGION,^DISEASE,,,2]/4}:7.1   │ 
  161. #ELSE
  162. │«^DISEASE:20»║ [^REGION,^DISEASE,1]:7 ║[^REGION,^DISEASE,,1]:6 │  {[^REGION,^DISEASE,,2]/4}:7.1   ║[^REGION,^Disease,,,1]:7 │  {[^REGION,^DISEASE,,,2]/4}:7.1   │
  163. #ENDIF
  164. #ENDIF
  165. #ENDFOR
  166. └────────────────────╨─────────╨───────┴────────────╨────────┴────────────┘
  167. #ENDFOR
  168. * REGION
  169.  
  170. #USESSUM COUNT COUNTY DISEASE TIME1 TIME2 TIME3
  171.  
  172. #FOREACH COUNTY
  173. .TOPIC ^COUNTY /NOWRAP
  174.  « Region »« State »« County »« Disease »« Criteria for highlighting |CRITERIA»
  175.  
  176.                    Table 1. Reported Cases of Selected Notifiable Diseases
  177.                             County ~^COUNTY~ 
  178.                             Week No ~@CURWEEK of 19@CURYEAR ~
  179.  
  180. ┌────────────────────╥─────────╥────────────────────╥─────────────────────┐
  181. │                    ║ MMWR Wk ║ Past 4 week period ║ Past 52 week period │
  182. │ Disease            ║  Nº @CURWEEK  ║  19@CURYEAR    average   ║  19@CURYEAR     average   │
  183. │                    ║   19@CURYEAR  ║   No. │last @YEARBACK years║   No.  │last @YEARBACK years│
  184. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  185. │ Total              ║ [^COUNTY,,1]:7 ║[^COUNTY,,,1]:6 │  {[^COUNTY,,,2]/4}:7.1   ║[^COUNTY,,,,1]:7 │  {[^COUNTY,,,,2]/4}:7.1   │
  186. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  187. #FOREACH DISEASE
  188. #IF 2*[^COUNTY,^DISEASE,1] > [^COUNTY,^DISEASE,,1] AND [^COUNTY,^DISEASE,1] > 3
  189. │«^DISEASE:20»║ ~[^COUNTY,^DISEASE,1]:7~ ║ ~[^COUNTY,^DISEASE,,1]:5~ │  {[^COUNTY,^DISEASE,,2]/4}:7.1   ║ [^COUNTY,^Disease,,,1]:6 │  {[^COUNTY,^DISEASE,,,2]/4}:7.1   │ 
  190. #ELSE
  191. #IF [^COUNTY,^DISEASE,,1] > {[^COUNTY,^DISEASE,,2]/2}:4.1 AND [^COUNTY,^DISEASE,,1] > 5
  192. │«^DISEASE:20»║ [^COUNTY,^DISEASE,1]:7 ║ ~[^COUNTY,^DISEASE,,1]:5~ │  ~{[^COUNTY,^DISEASE,,2]/4}:7.1~   ║ [^COUNTY,^Disease,,,1]:6 │  {[^COUNTY,^DISEASE,,,2]/4}:7.1   │ 
  193. #ELSE
  194. │«^DISEASE:20»║ [^COUNTY,^DISEASE,1]:7 ║[^COUNTY,^DISEASE,,1]:6 │  {[^COUNTY,^DISEASE,,2]/4}:7.1   ║[^COUNTY,^Disease,,,1]:7 │  {[^COUNTY,^DISEASE,,,2]/4}:7.1   │
  195. #ENDIF
  196. #ENDIF
  197. #ENDFOR
  198. └────────────────────╨─────────╨───────┴────────────╨────────┴────────────┘
  199.  
  200. #ENDFOR
  201.  
  202. #USESSUM COUNT COUNTY DISEASE TIME1 TIME2 
  203. .TOPIC DISEASE /NOWRAP
  204.      «Index»  «State»  «Region»  «County»  «Criteria for highlighting|CRITERIA»
  205.  
  206.                  ~Communicable Disease Notification by Disease~
  207.  
  208.      Select a highlighted disease name:
  209.  
  210. #FOREACH DISEASE
  211.      « ^DISEASE » \
  212. #IF 2*[^COUNTY,^DISEASE,1] > [^COUNTY,^DISEASE,,1] AND [^COUNTY,^DISEASE,1] > 3
  213. ~Cases for week @CURWEEK > previous 3 weeks!~
  214. #ELSE
  215. #IF [^COUNTY,^DISEASE,,1] > {[^COUNTY,^DISEASE,,2]/2}:4.1 AND [^COUNTY,^DISEASE,,1] > 5
  216. ~Cases for current 4 weeks > 2*average, same 4 weeks!~
  217. #ELSE
  218.  
  219. #ENDIF
  220. #ENDIF
  221. #ENDFOR
  222. #USESSUM COUNT COUNTY DISEASE TIME1 TIME2 TIME3
  223. #FOREACH DISEASE
  224. .TOPIC ^DISEASE /NOWRAP
  225.  « Index »« State »« Region »« County »« Disease »« Criteria for highlighting |CRITERIA»
  226.  
  227.                    Table 1. Reported Cases of ~^DISEASE ~
  228.                             ~All Counties~ 
  229.                             Week No~ @CURWEEK of 19@CURYEAR ~
  230.  
  231. ┌────────────────────╥─────────╥────────────────────╥─────────────────────┐
  232. │                    ║ MMWR Wk ║ Past 4 week period ║ Past 52 week period │
  233. │ County             ║  Nº @CURWEEK  ║  19@CURYEAR    average   ║  19@CURYEAR     average   │
  234. │                    ║   19@CURYEAR  ║   No. │last @YEARBACK years║   No.  │last @YEARBACK years│
  235. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  236. │ Total              ║ [,^DISEASE,1]:7 ║[,^DISEASE,,1]:6 │  {[,^DISEASE,,2]/4}:7.1   ║[,^DISEASE,,,1]:7 │  {[,^DISEASE,,,2]/4}:7.1   │
  237. ├────────────────────╫─────────╫───────┼────────────╫────────┼────────────┤
  238. #FOREACH COUNTY
  239. #IF 2*[^COUNTY,^DISEASE,1] > [^COUNTY,^DISEASE,,1] AND [^COUNTY,^DISEASE,1] > 3
  240. │ «^COUNTY:18» ║ ~[^COUNTY,^DISEASE,1]:7~ ║ ~[^COUNTY,^DISEASE,,1]:5~ │  {[^COUNTY,^DISEASE,,2]/4}:7.1   ║ [^COUNTY,^Disease,,,1]:6 │  {[^COUNTY,^DISEASE,,,2]/4}:7.1   │ 
  241. #ELSE
  242. #IF [^COUNTY,^DISEASE,,1] > {[^COUNTY,^DISEASE,,2]/2}:4.1 AND [^COUNTY,^DISEASE,,1] > 5
  243. │ «^COUNTY:18» ║ [^COUNTY,^DISEASE,1]:7 ║ ~[^COUNTY,^DISEASE,,1]:5~ │  ~{[^COUNTY,^DISEASE,,2]/4}:7.1~   ║ [^COUNTY,^Disease,,,1]:6 │  {[^COUNTY,^DISEASE,,,2]/4}:7.1   │ 
  244. #ELSE
  245. │« ^COUNTY:19»║ [^COUNTY,^DISEASE,1]:7 ║[^COUNTY,^DISEASE,,1]:6 │  {[^COUNTY,^DISEASE,,2]/4}:7.1   ║[^COUNTY,^Disease,,,1]:7 │  {[^COUNTY,^DISEASE,,,2]/4}:7.1   │
  246. #ENDIF
  247. #ENDIF
  248. #ENDFOR
  249. └────────────────────╨─────────╨───────┴────────────╨────────┴────────────┘
  250.  
  251. #ENDFOR
  252.  
  253. .TOPIC CRITERIA
  254.  « Index »« State »« Region »« County »« Disease »       
  255.  
  256. Criteria for ~highlighting~ a county or a disease:
  257.  
  258.        ■ More cases in the current week than in the past 3 weeks
  259.  
  260. or     ■ Twice as many cases in the past 4 weeks than the average over the 
  261.          past @YEARBACK years.